from app import db
class User(db.Model):
    __tablename__="user"
    uid = db.Column(db.BigInteger,primary_key=True,comment="用户id")
    name = db.Column(db.String(100),nullable=False,comment="姓名")

db.create_all()



class YH(db.Model):
    uid1 = db.Column(db.BigInteger, primary_key=True, comment="用户id")
    name1=db.Column(db.Column(50),comment="昵称")
    mobile=db.Column(db.Column(50),comment="手机号")
    tx=db.Column(db.Column(200),comment="头像")
    dj=db.Column(db.Column(50),comment="会员等级")
    je1=db.Column(db.Column(50),comment="金额")


class JLB(db.Model):
    uid2=db.Column(db.BigInteger, primary_key=True, comment="用户id")
    st=db.Column(db.Column(50),comment="开始时间")
    et=db.Column(db.Column(50),comment="结束时间")

class GMJL(db.Model):
    uid3=db.Column(db.BigInteger, primary_key=True, comment="用户id")
    nx = db.Column(db.Column(50), comment="购买年限")
    je3 = db.Column(db.Column(50), comment="金额")
    sjzfje3 = db.Column(db.Column(50), comment="实际支付金额")
    zk = db.Column(db.Column(50), comment="折扣")
    zfzt3 = db.Column(db.Column(50), comment="支付状态")

class VKCB(db.Model):
    uid4 = db.Column(db.BigInteger, primary_key=True, comment="用户id")
    kcid4=db.Column(db.Column(50), comment="课程id")


class SFDLB(db.Model):
    uid5 = db.Column(db.BigInteger, primary_key=True, comment="用户id")
    sfpt5 = db.Column(db.Column(50), comment="三方平台")
    token5 = db.Column(db.Column(50), comment="token")
    uid51 = db.Column(db.Column(50), comment="uid")


class LXB(db.Model):
    name6=db.Column(db.Column(50), comment="名称")


class BQB(db.Model):
    uid7 = db.Column(db.BigInteger, primary_key=True, comment="用户id")
    sfqy7 = db.Column(db.Column(50), comment="是否启用")


class FLB(db.Model):
    name8 = db.Column(db.Column(50),comment="名称")
    tp8 = db.Column(db.Column(50),comment="图片")
    kezs8 = db.Column(db.Column(50),comment="课程总数")
    ms8 = db.Column(db.Column(50),comment="描述")
    sc8 = db.Column(db.Column(50),comment="时长")
    zpjs8 = db.Column(db.Column(50),comment="总评价数")


class KCB(db.Model):
    name9 = db.Column(db.Column(50), comment="名称")
    tp9 = db.Column(db.Column(50), comment="图片")
    ms9 = db.Column(db.Column(50), comment="描述")
    gzzs9 = db.Column(db.Column(50), comment="关注总数")
    sffb9 = db.Column(db.Column(50), comment="是否发布")
    llcs9 = db.Column(db.Column(50), comment="浏览次数")
    sslx9 = db.Column(db.Column(50), comment="所属类型")


class KCBQB(db.Model):
    ke10 = db.Column(db.Column(50),comment="课程")
    bq10 = db.Column(db.Column(50),comment="标签")


class KCFLB(db.Model):
    ke11 = db.Column(db.Column(50), comment="课程")
    fl11 = db.Column(db.Column(50), comment="分类")



class ZJB(db.Model):
    name12 = db.Column(db.Column(50), comment="名称")
    js12 = db.Column(db.Column(50), comment="节数")
    sp12 = db.Column(db.Column(50), comment="视频")
    ke12 = db.Column(db.Column(50), comment="课程")

class PLFLB(db.Model):
    name13 = db.Column(db.Column(50), comment="名称")


class PJB(db.Model):
    bt14 = db.Column(db.Column(50), comment="标题")
    zhfs14 = db.Column(db.Column(50), comment="总回复数")
    zcks14 = db.Column(db.Column(50), comment="总查看数")
    sfzhhf14 = db.Column(db.Column(50), comment="是否最后回复")
    pid14 = db.Column(db.Column(50), comment="pid")
    sfzd14 = db.Column(db.Column(50), comment="是否置顶")


class XLYKCB(db.Model):
    bt15 = db.Column(db.Column(50), comment="标题")
    js15 = db.Column(db.Column(50), comment="介绍")
    tp15 = db.Column(db.Column(50), comment="图片")
    jg15 = db.Column(db.Column(50), comment="价格")
    kc15 = db.Column(db.Column(50), comment="库存")


class GWC(db.Model):
    uid16 = db.Column(db.BigInteger, primary_key=True, comment="用户id")
    kc16 = db.Column(db.Column(50), comment="课程")
    sl16 = db.Column(db.Column(50), comment="数量")


class DDB(db.Model):
    uid17 = db.Column(db.BigInteger, primary_key=True, comment="用户id")
    ddh17 = db.Column(db.Column(50), comment="订单号")
    kc17 = db.Column(db.Column(50), comment="课程")
    sl17 = db.Column(db.Column(50), comment="数量")
    dj17 = db.Column(db.Column(50), comment="单价")
    zjg17 = db.Column(db.Column(50), comment="总价格")
    zt17 = db.Column(db.Column(50), comment="状态")
    zfblsh17 = db.Column(db.Column(50), comment="支付宝流水号")